At 16:16 +0300 on 30/06/1999, webmaster wrote:
> Both id_look and ident are varchars.. So what's wrong with || operator? There
> is an error parsing the querry near || ...
>
> Who is stupid? Me, or postgresql 6.4.2 :) ? It look like legal expression for
> me...
Old problem... "||" doesn't have associativity, so when you use a||b||c, it
gets mixed up. Solution - use (a||b) || c. Preferably ((a||b)||c).
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma